Exploratory Data Analysis
Dataset Overview
| Metric |
Value |
| Number of Rows |
11760 |
| Number of Columns |
17 |
| Memory in MB |
5.16 MB |
| Duplicates |
0 |
Missing Values
| column |
missing_count |
| UserID |
0 |
| Taken_product |
0 |
| Yearly_avg_view_on_travel_page |
581 |
| preferred_device |
53 |
| total_likes_on_outstation_checkin_given |
381 |
| yearly_avg_Outstation_checkins |
75 |
| member_in_family |
0 |
| preferred_location_type |
31 |
| Yearly_avg_comment_on_travel_page |
206 |
| total_likes_on_outofstation_checkin_received |
0 |
| week_since_last_outstation_checkin |
0 |
| following_company_page |
103 |
| montly_avg_comment_on_company_page |
0 |
| working_flag |
0 |
| travelling_network_rating |
0 |
| Adult_flag |
0 |
| Daily_Avg_mins_spend_on_traveling_page |
0 |
Numeric Summary
| index |
count |
mean |
std |
min |
25% |
50% |
75% |
max |
| UserID |
11760.0 |
1.005880e+06 |
3394.963917 |
1000001.0 |
1002940.75 |
1005880.5 |
1008820.25 |
1011760.0 |
| Yearly_avg_view_on_travel_page |
11179.0 |
2.808308e+02 |
68.182958 |
35.0 |
232.00 |
271.0 |
324.00 |
464.0 |
| total_likes_on_outstation_checkin_given |
11379.0 |
2.817048e+04 |
14385.032134 |
3570.0 |
16380.00 |
28076.0 |
40525.00 |
252430.0 |
| Yearly_avg_comment_on_travel_page |
11554.0 |
7.479003e+01 |
24.026650 |
3.0 |
57.00 |
75.0 |
92.00 |
815.0 |
| total_likes_on_outofstation_checkin_received |
11760.0 |
6.531699e+03 |
4706.613785 |
1009.0 |
2940.75 |
4948.0 |
8393.25 |
20065.0 |
| week_since_last_outstation_checkin |
11760.0 |
3.203571e+00 |
2.616365 |
0.0 |
1.00 |
3.0 |
5.00 |
11.0 |
| montly_avg_comment_on_company_page |
11760.0 |
2.866156e+01 |
48.660504 |
11.0 |
17.00 |
22.0 |
27.00 |
500.0 |
| travelling_network_rating |
11760.0 |
2.712245e+00 |
1.080887 |
1.0 |
2.00 |
3.0 |
4.00 |
4.0 |
| Adult_flag |
11760.0 |
7.938776e-01 |
0.851823 |
0.0 |
0.00 |
1.0 |
1.00 |
3.0 |
| Daily_Avg_mins_spend_on_traveling_page |
11760.0 |
1.381743e+01 |
9.070657 |
0.0 |
8.00 |
12.0 |
18.00 |
270.0 |
Outliers
{'UserID': 0, 'Yearly_avg_view_on_travel_page': 11, 'total_likes_on_outstation_checkin_given': 4, 'Yearly_avg_comment_on_travel_page': 40, 'total_likes_on_outofstation_checkin_received': 916, 'week_since_last_outstation_checkin': 0, 'montly_avg_comment_on_company_page': 242, 'travelling_network_rating': 0, 'Adult_flag': 680, 'Daily_Avg_mins_spend_on_traveling_page': 350}
Univariate Analysis
Bivariate Analysis